﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace SGArchiveSystem7x.Models
{
    /// <summary>
    /// grid 的列 数据类
    /// </summary>
    public class CColumnsModel
    {
        /*表头描述
         * 1.FieldValue:键值
         * 2.FieldText:显示名称
         * 3.Hidden：是否隐藏
         * 4.Editor：启用编辑(目前我们系统暂不提供列编辑功能，留在以后扩展用)
         * 5.Formate: 格式列，如果不要格式则为空
         * 6.Frozen: 是否固定在列的最前面
         * 7.Len:列的长度
         */

        #region 表头列属性
        /// <summary>
        /// 数据库里的字段键值
        /// </summary>
        public String FieldValue { get; set; }
        /// <summary>
        /// 显示的名称
        /// </summary>
        public String FieldText { get; set; }
        /// <summary>
        /// 列的长度
        /// </summary>
        public int Len { get; set; }
        /// <summary>
        /// 是否隐藏
        /// </summary>
        public bool Hidden { get; set; }
        /// <summary>
        /// 是否可以启用编辑
        /// </summary>
        public String Editor { get; set; }
        /// <summary>
        /// 格式渲染函数
        /// </summary>
        public String Formate { get; set; }
        /// <summary>
        /// 是否固定在最前面
        /// </summary>
        public bool Frozen { get; set; }
        #endregion

        #region 不同的表格列建立

        #region 建立运营列
        public static List<CColumnsModel> Create_OperationColumns()
        {
            List<CColumnsModel> list = new List<CColumnsModel>();
            CColumnsModel m = new CColumnsModel();
            m = new CColumnsModel();
            m.FieldText = "电子文件";
            m.FieldValue = "YY_DZWZ";
            m.Formate = "formatFile";
            m.Frozen = true;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "上传";
            m.FieldValue = "YY_SC";
            m.Formate = "formatUpload";
            m.Frozen = true;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "归档号";
            m.FieldValue = "YY_BH";
            m.Formate = "";
            m.Frozen = true;
            m.Len = 150;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "标题名称";
            m.FieldValue = "YY_TM";
            m.Formate = "";
            m.Frozen = true;
            m.Len = 300;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "部门";
            m.FieldValue = "YY_DEPID";
            m.Formate = "formatDEP";
            m.Frozen = true;
            m.Len = 150;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "归档时间";
            m.FieldValue = "YY_DATE";
            m.Formate = "formatDate";
            m.Frozen = true;
            m.Len = 150;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "归档人";
            m.FieldValue = "YY_USERNAME";
            m.Formate = "";
            m.Frozen = true;
            m.Len = 120;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "运营状态";
            m.FieldValue = "YY_STATUS";
            m.Formate = "formatStatus";
            m.Frozen = true;
            m.Len = 120;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "编辑";
            m.FieldValue = "YY_Edit";
            m.Formate = "formatEdit";
            m.Frozen = true;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "编辑";
            m.FieldValue = "YY_Del";
            m.Formate = "formatDel";
            m.Frozen = true;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);
            return list;
        }

        #endregion

        #region 档案日志列
        public static List<CColumnsModel> Create_LogArchiveListColumns()
        {
            List<CColumnsModel> list = new List<CColumnsModel>();
            CColumnsModel m = new CColumnsModel();
            m.FieldText = "档号";
            m.FieldValue = "LOG_ANAME";
            m.Formate = "";
            m.Frozen = true;
            m.Len = 150;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "档案类型";
            m.FieldValue = "LOG_ARID";
            m.Formate = "formatTYPE";
            m.Frozen = true;
            m.Len = 150;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "操作时间";
            m.FieldValue = "LOG_DATE";
            m.Formate = "formatDate";
            m.Frozen = true;
            m.Len = 150;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "操作人";
            m.FieldValue = "LOG_UNAME";
            m.Formate = "";
            m.Frozen = true;
            m.Len = 150;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "操作类型";
            m.FieldValue = "LOG_TYPE";
            m.Formate = "";
            m.Frozen = true;
            m.Len = 150;
            m.Hidden = false;
            list.Add(m);

            return list;
        }
        #endregion

        #region 建立部门权限列
        public static List<CColumnsModel> Create_DepartmentArchiveListColumns(bool edit)
        {
            List<CColumnsModel> list = new List<CColumnsModel>();
            CColumnsModel m = new CColumnsModel();
            m.FieldText = "部门名称";
            m.FieldValue = "sDepartmentName";
            m.Formate = "";
            m.Frozen = true;
            m.Len = 150;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "显示";
            m.FieldValue = "iShow";
            m.Formate = "formatStatusI";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "浏览电子件";
            m.FieldValue = "iView";
            m.Formate = "formatStatusI";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "打印电子件";
            m.FieldValue = "iPrint";
            m.Formate = "formatStatusI";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "下载电子件";
            m.FieldValue = "iDown";
            m.Formate = "formatStatusI";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "编辑信息";
            m.FieldValue = "iEdit";
            m.Formate = "formatStatusI";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "审批借阅";
            m.FieldValue = "iApproval";
            m.Formate = "formatStatusI";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            if (edit)
            {
                m = new CColumnsModel();
                m.FieldText = "修改";
                m.FieldValue = "iDepartmentID";
                m.Formate = "formatEdit";
                m.Frozen = false;
                m.Len = 80;
                m.Hidden = false;
                list.Add(m);
            }
            return list;
        }
        #endregion

        #region 建立角色列
        public static List<CColumnsModel> Create_RoleListColumns()
        {
            List<CColumnsModel> list = new List<CColumnsModel>();
            CColumnsModel m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "角色名称";
            else
                m.FieldText = "Name";
            m.FieldValue = "ROLE_NAME";
            m.Formate = "";
            m.Frozen = true;
            m.Len = 150;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "角色备注";
            else
                m.FieldText = "Remark";
            m.FieldValue = "ROLE_REAMARK";
            m.Formate = "";
            m.Len = 500;
            m.Frozen = false;
            m.Hidden = false;
            list.Add(m);

            //m = new CColumnsModel();
            //m.FieldText = "浏览密级";
            //m.FieldValue = "ROLE_MJ";
            //m.Formate = "formatMJ";
            //m.Frozen = false;
            //m.Len = 80;
            //m.Hidden = true;
            //list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "是否启用";
            else
                m.FieldText = "Status";
            m.FieldValue = "ROLE_STATUS";
            m.Formate = "formatStatus";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);


            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "编辑";
            else
                m.FieldText = "Edit";
            m.FieldValue = "ROLE_ID";
            m.Formate = "formatEdit";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            return list;
        }
        /// <summary>
        /// 登录日志
        /// </summary>
        /// <returns></returns>
        public static List<CColumnsModel> Create_LogLoginListColumns()
        {
            List<CColumnsModel> list = new List<CColumnsModel>();
            CColumnsModel m = new CColumnsModel();
            m.FieldText = "登录时间";
            m.FieldValue = "LOG_DATE";
            m.Formate = "formatDATE";
            m.Frozen = true;
            m.Len = 150;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "登录用户名";
            m.FieldValue = "U_NAME";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 300;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "登录人姓名";
            m.FieldValue = "U_RNAME";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "登陆方式";
            m.FieldValue = "LOG_TYPE";
            m.Formate = "formatType";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "登陆时的IP";
            m.FieldValue = "LOG_IP";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "是否绑定IP";
            m.FieldValue = "U_ISIP";
            m.Formate = "formatISIP";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "绑定的IP地址";
            m.FieldValue = "U_IP";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            return list;
        }
        /// <summary>
        /// 用户列
        /// </summary>
        /// <returns></returns>
        public static List<CColumnsModel> Create_UserListColumns()
        {
            List<CColumnsModel> list = new List<CColumnsModel>();
            CColumnsModel m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "账号";
            else
                m.FieldText = "Name";
            m.FieldValue = "U_NAME";
            m.Formate = "";
            m.Frozen = true;
            m.Len = 100;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "姓名";
            else
                m.FieldText = "Full Name";
            m.FieldValue = "U_RNAME";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 100;
            m.Hidden = false;
            list.Add(m);

            //m = new CColumnsModel();
            //m.FieldText = "AD域";
            //m.FieldValue = "U_AD";
            //m.Formate = "formatAD";
            //m.Frozen = false;
            //m.Len = 80;
            //m.Hidden = false;
            //list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "IP地址";
            else
                m.FieldText = "IP Addr";
            m.FieldValue = "U_IP";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 180;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "IP";
            m.FieldValue = "U_ISIP";
            m.Formate = "formatIP";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "联系电话";
            else
                m.FieldText = "Phone";
            m.FieldValue = "U_V04";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "电子邮箱";
            else
                m.FieldText = "Email";
            m.FieldValue = "U_V01";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            //m = new CColumnsModel();
            //m.FieldText = "部门";
            //m.FieldValue = "U_DEPID";
            //m.Formate = "formatDep";
            //m.Frozen = false;
            //m.Len = 80;
            //m.Hidden = false;
            //list.Add(m);

            //m = new CColumnsModel();
            //m.FieldText = "职位";
            //m.FieldValue = "U_I01";
            //m.Formate = "";
            //m.Frozen = false;
            //m.Len = 100;
            //m.Hidden = false;
            //list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "角色名称";
            else
                m.FieldText = "Role";
            m.FieldValue = "ROLE_NAME";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "建立时间";
            else
                m.FieldText = "Create Time";
            m.FieldValue = "U_D01";
            m.Formate = "formatDate";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "是否启用";
            else
                m.FieldText = "Status";
            m.FieldValue = "U_STATUS";
            m.Formate = "formatStatus";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "备注";
            else
                m.FieldText = "Remark";
            m.FieldValue = "U_REMARK";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "编辑";
            else
                m.FieldText = "Edit";
            m.FieldValue = "U_ID";
            m.Formate = "formatEdit";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "重置密码";
            else
                m.FieldText = "Init Password";
            m.FieldValue = "U_ID2";
            m.Formate = "formatReset";
            m.Frozen = false;
            m.Len = 100;
            m.Hidden = false;
            list.Add(m);

            return list;
        }
        #endregion

        #region 建立档案列
        /// <summary>
        /// 建立档案列
        /// </summary>
        /// <param name="view">是否显示电子文件列</param>
        /// <param name="edit">是否显示编辑列</param>
        /// <param name="del">是否显示删除列</param>
        /// <param name="upload">是否显示上传列</param>
        /// <param name="fb">是否显示发布列</param>
        /// <param name="archivetype">档案类型</param>
        /// <returns></returns>
        public static List<CColumnsModel> Create_ArchiveListColumns(int archivetype, bool view, bool upload, bool edit, bool del, bool fb, bool lsfb)
        {
            List<CColumnsModel> list = new List<CColumnsModel>();
            CColumnsModel m;
            if (view)
            {
                /*
                m = new CColumnsModel();
                m.FieldText = "电子文件";
                m.FieldValue = "DZWJ";
                m.Formate = "formatFile";
                m.Frozen = true;
                m.Len = 80;
                m.Hidden = false;
                list.Add(m);*/
            }
            if (upload)
            {
                /*
                m = new CColumnsModel();
                m.FieldText = "上传";
                m.FieldValue = "UPLOAD";
                m.Formate = "formatUpload";
                m.Frozen = true;
                m.Len = 80;
                m.Hidden = false;
                list.Add(m);*/
            }

            if (edit)
            {
                m = new CColumnsModel();
                m.FieldText = "编辑";
                m.FieldValue = "EDIT";
                m.Formate = "formatEdit";
                m.Frozen = true;
                m.Len = 80;
                m.Hidden = false;
                list.Add(m);
            }

            if (del)
            {
                m = new CColumnsModel();
                m.FieldText = "删除";
                m.FieldValue = "DEL";
                m.Formate = "formatDel";
                m.Frozen = true;
                m.Len = 80;
                m.Hidden = false;
                list.Add(m);
            }

            if (fb)
            {
                m = new CColumnsModel();
                m.FieldText = "发布";
                m.FieldValue = "FB";
                m.Formate = "formatFB";
                m.Frozen = true;
                m.Len = 80;
                m.Hidden = false;
                list.Add(m);


            }
            if (lsfb)
            {
                m = new CColumnsModel();
                m.FieldText = "临时发布";
                m.FieldValue = "FB1";
                m.Formate = "formatLSFB";
                m.Frozen = true;
                m.Len = 80;
                m.Hidden = false;
                list.Add(m);
            }
            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "在库情况";
            else
                m.FieldText = "Status";
            m.FieldValue = "KFZT";
            m.Formate = "formatKFZT";
            m.Frozen = true;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "状态";
            else
                m.FieldText = "Status";
            m.FieldValue = "AJZT";
            m.Formate = "formatAJZT";
            m.Frozen = true;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "入库时间";
            else
                m.FieldText = "Out the warehous' time";
            
            m.FieldValue = "D02";
            m.Formate = "formatDate";
            m.Frozen = true;
            m.Len = 150;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "出库时间";
            else
                m.FieldText = "In the warehous' time";
            m.FieldValue = "D01";
            m.Formate = "formatDate";
            m.Frozen = true;
            m.Len = 100;
            m.Hidden = false;
            list.Add(m);

            int count = 0;
            var listFields = SGArchiveSystem7xDB.Linq.T_ArchiveFieldsDal.Get_ArchiveFields(out count, 1, archivetype, -1, -1, 1, -1, -1);
            foreach (var n in listFields)
            {
                m = new CColumnsModel();
                m.FieldText = n.AF_NAME;
                m.FieldValue = n.AF_FIELD;
                m.Len = n.AF_LEN;
                if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                {
                    if (n.AF_TYPE == "唯一")
                        m.Frozen = true;
                    else if (n.AF_TYPE == "日期")
                        m.Formate = "formatDate";
                    else if (n.AF_TYPE == "文本" || n.AF_TYPE == "数字" || n.AF_TYPE == "年份")
                        m.Formate = "";
                    else if (n.AF_TYPE == "部门")
                        m.Formate = "formatDeparetment";
                    else if (n.AF_TYPE == "词典")
                        m.Formate = "formatWordBody";
                }
                else
                {
                    if (n.AF_TYPE == "Key")
                        m.Frozen = true;
                    else if (n.AF_TYPE == "Date")
                        m.Formate = "formatDate";
                    else if (n.AF_TYPE == "Text" || n.AF_TYPE == "Number" || n.AF_TYPE == "Year")
                        m.Formate = "";
                    else if (n.AF_TYPE == "Dep")
                        m.Formate = "formatDeparetment";
                    else if (n.AF_TYPE == "Word")
                        m.Formate = "formatWordBody";
                }
                list.Add(m);
            }

            return list;
        }
        #endregion

        #region 建立借阅列
        public static List<CColumnsModel> Create_BrrColumns()
        {
            List<CColumnsModel> list = new List<CColumnsModel>();
            CColumnsModel m = new CColumnsModel();
            m.FieldText = "档案类型";
            m.FieldValue = "ATYPE";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 150;
            m.Hidden = false;
            list.Add(m);

            //m = new CColumnsModel();
            //m.FieldText = "档案类型ID";
            //m.FieldValue = "ARID";
            //m.Formate = "";
            //m.Frozen = false;
            //m.Len = 0;
            //m.Hidden = true;
            //list.Add(m);

            //m = new CColumnsModel();
            //m.FieldText = "案卷或卷内";
            //m.FieldValue = "AJORJN";
            //m.Formate = "formatAJORJN";
            //m.Frozen = false;
            //m.Len = 0;
            //m.Hidden = true;
            //list.Add(m);

            //m = new CColumnsModel();
            //m.FieldText = "卷内ID";
            //m.FieldValue = "JNID";
            //m.Formate = "";
            //m.Frozen = false;
            //m.Len = 0;
            //m.Hidden = true;
            //list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "档号";
            m.FieldValue = "DH";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 300;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "题名";
            m.FieldValue = "TM";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "取消";
            m.FieldValue = "ARCHIVEID";
            m.Formate = "formatDel";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            return list;
        }
        #endregion

        #region  建立借出列
        public static List<CColumnsModel> Create_LendColumns()
        {
            List<CColumnsModel> list = new List<CColumnsModel>();
            CColumnsModel m = new CColumnsModel();
            m.FieldText = "状态";
            m.FieldValue = "BU_BUSERNAME";
            m.Formate = "formatStatus";
            m.Frozen = false;
            m.Len = 150;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "借出人";
            m.FieldValue = "BI_ATYPE";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "档案类型";
            m.FieldValue = "BI_DH";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "档号";
            m.FieldValue = "BI_TM";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "题名";
            m.FieldValue = "BU_DATE";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 300;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "利用目的";
            m.FieldValue = "BU_DATE";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 100;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "申请时间";
            m.FieldValue = "BU_DATE";
            m.Formate = "formatDate";
            m.Frozen = false;
            m.Len = 100;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "审批时间";
            m.FieldValue = "BU_DATE";
            m.Formate = "formatDate";
            m.Frozen = false;
            m.Len = 100;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "审批人";
            m.FieldValue = "BU_DATE";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 100;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "审批结果";
            m.FieldValue = "BU_DATE";
            m.Formate = "formatResult";
            m.Frozen = false;
            m.Len = 100;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "归还日期";
            m.FieldValue = "BU_DATE";
            m.Formate = "formatDate";
            m.Frozen = false;
            m.Len = 100;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "是否逾期";
            m.FieldValue = "BU_DATE";
            m.Formate = "formatOverdue";
            m.Frozen = false;
            m.Len = 100;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "备注";
            m.FieldValue = "BU_DATE";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 100;
            m.Hidden = false;
            list.Add(m);
            return list;
        }
        #endregion

        #region  建立浏览列
        public static List<CColumnsModel> Create_BrowseColumns()
        {
            List<CColumnsModel> list = new List<CColumnsModel>();
            CColumnsModel m = new CColumnsModel();
            //m.FieldText = "附件";
            //m.FieldValue = "BI_ATYPE";
            //m.Formate = "";
            //m.Frozen = false;
            //m.Len = 150;
            //m.Hidden = false;
            //list.Add(m);

            //m = new CColumnsModel();
            m.FieldText = "状态";
            m.FieldValue = "BI_STATUS";
            m.Formate = "formatStatus";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "审批情况";
            m.FieldValue = "BI_SPSTATUS";
            m.Formate = "formatSituation";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "审批人";
            m.FieldValue = "BI_TM";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "档案类型";
            m.FieldValue = "BI_ARID";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 100;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "档号";
            m.FieldValue = "BI_DH";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 150;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "题名";
            m.FieldValue = "BI_TM";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 300;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "申请时间";
            m.FieldValue = "BU_DATE";
            m.Formate = "formatDate";
            m.Frozen = false;
            m.Len = 150;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "利用目的";
            m.FieldValue = "BU_DATE";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 150;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "借阅时间";
            m.FieldValue = "BU_DATE";
            m.Formate = "formatDate";
            m.Frozen = false;
            m.Len = 150;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "备注";
            m.FieldValue = "BU_DATE";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);
            return list;
        }
        #endregion

        #region 建立审批列
        public static List<CColumnsModel> Create_SPColumns(bool issp, bool isnowview, bool isend, bool isme)
        {

            List<CColumnsModel> list = new List<CColumnsModel>();
            CColumnsModel m = new CColumnsModel();
            if (!isme)
            {
                m = new CColumnsModel();
                m.FieldText = "浏览";
                m.FieldValue = "BI_DH1";
                m.Formate = "formatFile";
                m.Frozen = false;
                m.Len = 80;
                m.Hidden = false;
                list.Add(m);
            }

            m = new CColumnsModel();
            m.FieldText = "借阅情况";
            m.FieldValue = "BI_STATUS";
            m.Formate = "formatStatus";
            m.Frozen = false;
            m.Len = 60;
            m.Hidden = true;
            list.Add(m);

            //m = new CColumnsModel();
            //m.FieldText = "授权类型";
            //m.FieldValue = "BI_SPSTATUS";
            //m.Formate = "formatSPStatus";
            //m.Frozen = false;
            //m.Len = 150;
            //m.Hidden = true;
            //list.Add(m);

            //m = new CColumnsModel();
            //m.FieldText = "审批结果";
            //m.FieldValue = "BI_SPVALUE";
            //m.Formate = "formatSPValue";
            //m.Frozen = false;
            //m.Len = 80;
            //m.Hidden = false;
            //list.Add(m);

            if (issp)
            {
                //m = new CColumnsModel();
                //m.FieldText = "借阅类型";
                //m.FieldValue = "BU_TYPE";
                //m.Formate = "formatType";
                //m.Frozen = false;
                //m.Len = 80;
                //m.Hidden = false;
                //list.Add(m);
            }
            if (isme)
            {
                m = new CColumnsModel();
                m.FieldText = "借阅人";
                m.FieldValue = "BU_BUSERNAME";
                m.Formate = "";
                m.Frozen = false;
                m.Len = 60;
                m.Hidden = false;
                list.Add(m);

            }

            m = new CColumnsModel();
            m.FieldText = "档案类型";
            m.FieldValue = "BI_ATYPE";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "档号";
            m.FieldValue = "BI_DH";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 150;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "题名";
            m.FieldValue = "BI_TM";
            m.Formate = "";
            m.Frozen = false;
            m.Len =250;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "利用目的";
            m.FieldValue = "BU_LYMD";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "登记时间";
            m.FieldValue = "BU_DATE";
            m.Formate = "formatDate";
            m.Frozen = false;
            m.Len = 120;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "预计归还";
            m.FieldValue = "BI_YJGHDATE";
            m.Formate = "formatDate";
            m.Frozen = false;
            m.Len = 120;
            m.Hidden = false;
            list.Add(m);

            if (isend)
            {
                //m = new CColumnsModel();
                //m.FieldText = "实际归还时间";
                //m.FieldValue = "BI_SJGHDATE";
                //m.Formate = "formatDate";
                //m.Frozen = false;
                //m.Len = 80;
                //m.Hidden = false;
                //list.Add(m);

                m = new CColumnsModel();
                m.FieldText = "出库时间";
                m.FieldValue = "BI_D01";
                m.Formate = "formatDate";
                m.Frozen = false;
                m.Len = 120;
                m.Hidden = false;
                list.Add(m);

                m = new CColumnsModel();
                m.FieldText = "归还入库";
                m.FieldValue = "BI_D02";
                m.Formate = "formatDate";
                m.Frozen = false;
                m.Len = 120;
                m.Hidden = false;
                list.Add(m);
            }

            if (issp)
            {
                //m = new CColumnsModel();
                //m.FieldText = "审批人";
                //m.FieldValue = "BI_SPNAME";
                //m.Formate = "";
                //m.Frozen = false;
                //m.Len = 80;
                //m.Hidden = false;
                //list.Add(m);

                //m = new CColumnsModel();
                //m.FieldText = "审批时间";
                //m.FieldValue = "BI_SPDATE";
                //m.Formate = "formatDate";
                //m.Frozen = false;
                //m.Len = 80;
                //m.Hidden = false;
                //list.Add(m);

                m = new CColumnsModel();
                m.FieldText = "逾期天数";
                m.FieldValue = "BI_YQTS";
                m.Formate = "formatYQTS";
                m.Frozen = false;
                m.Len = 80;
                m.Hidden = false;
                list.Add(m);
            }
            if (isnowview)
            {
                m = new CColumnsModel();
                m.FieldText = "结束";
                m.FieldValue = "BI_ID";
                m.Formate = "formatEnd";
                m.Frozen = false;
                m.Len = 80;
                m.Hidden = false;
                list.Add(m);
            }
            if (isend)
            {
                if (!isme)
                { }
                else {
                //m = new CColumnsModel();
                //m.FieldText = "导出借阅审批表";
                //m.FieldValue = "BI_ID1";
                //m.Formate = "formatJYSP";
                //m.Frozen = false;
                //m.Len = 120;
                //m.Hidden = false;
                //list.Add(m);
                }
            }
            return list;
        }
        #endregion

        #region 建立出入库列
        public static List<CColumnsModel> Create_OutInKColumns(bool bOutKF)
        {
            List<CColumnsModel> list = new List<CColumnsModel>();
            CColumnsModel m = new CColumnsModel();
            m.FieldText = "当前状态";
            m.FieldValue = "BI_STATUS";
            m.Formate = "formatStatus";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            //m = new CColumnsModel();
            //m.FieldText = "审批结果";
            //m.FieldValue = "BI_SPSTATUS";
            //m.Formate = "formatSPValue";
            //m.Frozen = false;
            //m.Len = 80;
            //m.Hidden = false;
            //list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "借阅人";
            m.FieldValue = "BU_BUSERNAME";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "档案类型";
            m.FieldValue = "BI_ATYPE";
            m.Formate = "";
            m.Frozen = false;
            m.Len =80;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "档号";
            m.FieldValue = "BI_DH";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "题名";
            m.FieldValue = "BI_TM";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 150;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "预计归还时间";
            m.FieldValue = "BI_YJGHDATE";
            m.Formate = "formatDate";
            m.Frozen = false;
            m.Len =150;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "登记人";
            m.FieldValue = "BU_V02";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 150;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "最晚出库时间";
            m.FieldValue = "BI_LQDATE";
            m.Formate = "formatDate";
            m.Frozen = false;
            m.Len = 150;
            m.Hidden = true;
            list.Add(m);

            if (bOutKF)
            {
                m = new CColumnsModel();
                m.FieldText = "取消出库";
                m.FieldValue = "BI_ID";
                m.Formate = "formatEnd";
                m.Frozen = false;
                m.Len = 80;
                m.Hidden = true;
                list.Add(m);
            }

            return list;
        }
        #endregion

        #region 建立档案字段列
        public static List<CColumnsModel> Create_ArchiveFieldsColumns()
        {
            List<CColumnsModel> list = new List<CColumnsModel>();
            CColumnsModel m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "字段名称";
            else
                m.FieldText = "Name";
            m.FieldValue = "AF_NAME";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 100;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "字段类型";
            else
                m.FieldText = "Type";
            m.FieldValue = "AF_TYPE";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 100;
            m.Hidden = false;
            list.Add(m);

            //m = new CColumnsModel();
            //m.FieldText = "对应词典";
            //m.FieldValue = "AF_WORDID";
            //m.Formate = "formatWord";
            //m.Frozen = false;
            //m.Len = 100;
            //m.Hidden = true;
            //list.Add(m);


            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "显示长度";
            else
                m.FieldText = "Show Length";
            m.FieldValue = "AF_LEN";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 100;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "排序号";
            else
                m.FieldText = "Sort";
            m.FieldValue = "AF_ORDER";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 100;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "可否显示";
            else
                m.FieldText = "Display";
            m.FieldValue = "AF_SHOW";
            m.Formate = "formatStatus";
            m.Frozen = false;
            m.Len = 100;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "可否查询";
            else
                m.FieldText = "Query";
            m.FieldValue = "AF_QUERY";
            m.Formate = "formatStatus";
            m.Frozen = false;
            m.Len = 100;
            m.Hidden = false;
            list.Add(m);

            //m = new CColumnsModel();
            //m.FieldText = "可否编辑";
            //m.FieldValue = "AF_EDIT";
            //m.Formate = "formatStatus";
            //m.Frozen = false;
            //m.Len = 100;
            //m.Hidden = false;
            //list.Add(m);

            //m = new CColumnsModel();
            //m.FieldText = "可否统计";
            //m.FieldValue = "AF_STAT";
            //m.Formate = "formatStatus";
            //m.Frozen = false;
            //m.Len =100;
            //m.Hidden = false;
            //list.Add(m);

            //m = new CColumnsModel();
            //m.FieldText = "可否为空";
            //m.FieldValue = "AF_ISNULL";
            //m.Formate = "formatStatus";
            //m.Frozen = false;
            //m.Len = 100;
            //m.Hidden = false;
            //list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "编辑";
            else
                m.FieldText = "Edit";
            m.FieldValue = "AF_ID";
            m.Formate = "formatEdit";
            m.Frozen = false;
            m.Len = 100;
            m.Hidden = false;
            list.Add(m);

            return list;
        }
        #endregion
        #region 建立审批流列
        public static List<CColumnsModel> Create_SPFlowColumns()
        {

            List<CColumnsModel> list = new List<CColumnsModel>();
            CColumnsModel m = new CColumnsModel();
            m.FieldText = "借阅人";
            m.FieldValue = "BU_BUSERNAME";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "档案类型";
            m.FieldValue = "BI_ATYPE";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "档号";
            m.FieldValue = "BI_DH";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "题名";
            m.FieldValue = "BI_TM";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 150;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "利用目的";
            m.FieldValue = "BU_LYMD";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 150;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "借阅时间";
            m.FieldValue = "BU_DATE";
            m.Formate = "formatDate";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "预计归还时间";
            m.FieldValue = "BI_YJGHDATE";
            m.Formate = "formatDate";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "审批流程";
            m.FieldValue = "SPF_Stage";
            m.Formate = "formatStage";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);

            return list;
        }
        #endregion
        #region 建立AD域列
        public static List<CColumnsModel> Create_ADDomainColumns()
        {

            List<CColumnsModel> list = new List<CColumnsModel>();
            CColumnsModel m = new CColumnsModel();
            m.FieldText = "用户名";
            m.FieldValue = "AD_AccountName";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "姓名";
            m.FieldValue = "AD_DisplayName";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "电话";
            m.FieldValue = "AD_Telephone";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "邮箱";
            m.FieldValue = "AD_Email";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "组织机构";
            m.FieldValue = "AD_OU";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);
            return list;

        }
        #endregion

        #region 建立未授权列
        public static List<CColumnsModel> Create_NoSQColumns()
        {
            List<CColumnsModel> list = new List<CColumnsModel>();
            CColumnsModel m = new CColumnsModel();
            m.FieldText = "类型";
            m.FieldValue = "JK_Status";
            m.Formate = "formateStatus";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "档案类型";
            m.FieldValue = "AR_NAME";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "档号";
            m.FieldValue = "JK_ArchiveDH";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "年度";
            m.FieldValue = "JK_ND";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "题名";
            m.FieldValue = "JK_TM";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "监控时间";
            m.FieldValue = "JK_Date";
            m.Formate = "formatDate";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);

            return list;
        }
        #endregion

        #region 不在库房的档案
        public static List<CColumnsModel> Create_NotKFColumns()
        {
            List<CColumnsModel> list = new List<CColumnsModel>();
            CColumnsModel m = new CColumnsModel();
            m.FieldText = "在库情况";
            m.FieldValue = "KFZT";
            m.Formate = "formatKFZT";
            m.Frozen = true;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "状态";
            m.FieldValue = "AJZT";
            m.Formate = "formatAJZT";
            m.Frozen = true;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "档案类型";
            m.FieldValue = "AR_NAME";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "档号";
            m.FieldValue = "DH";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "年度";
            m.FieldValue = "ND";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);

            m = new CColumnsModel();
            m.FieldText = "题名";
            m.FieldValue = "TM";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 80;
            m.Hidden = true;
            list.Add(m);
            return list;
        }
        #endregion

        #region 监控列
        public static List<CColumnsModel> Create_JKColumns()
        {

            List<CColumnsModel> list = new List<CColumnsModel>();
            CColumnsModel m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "监控类型";
            else
                m.FieldText = "Monitoring Type";
            m.FieldValue = "JK_Type";
            m.Formate = "";
            m.Frozen = true;
            m.Len = 100;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "监控时间";
            else
                m.FieldText = "Monitoring Time";
            m.FieldValue = "JK_Date";
            m.Formate = "formatDate";
            m.Frozen = false;
            m.Len = 150;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "物品类型";
            else
                m.FieldText = "Item Type";
            m.FieldValue = "AR_NAME";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 100;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "物品编号";
            else
                m.FieldText = "Serial Number";
            m.FieldValue = "JK_ArchiveDH";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 150;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "批次号";
            else
                m.FieldText = "Batch number";
            m.FieldValue = "JK_FTM";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 200;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "品名";
            else
                m.FieldText = "Name";
            m.FieldValue = "JK_TM";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 200;
            m.Hidden = false;
            list.Add(m);

            m = new CColumnsModel();
            if (Models.Language._nowLanguage == SGArchiveSystem7xDB._VersionLanguage._Chs)
                m.FieldText = "人工操作人";
            else
                m.FieldText = "Operator";
            m.FieldValue = "JK_CLR";
            m.Formate = "";
            m.Frozen = false;
            m.Len = 60;
            m.Hidden = false;
            list.Add(m);

            //m = new CColumnsModel();
            //m.FieldText = "操作时间";
            //m.FieldValue = "JK_CLSJ";
            //m.Formate = "formatDate";
            //m.Frozen = false;
            //m.Len = 200;
            //m.Hidden = false;
            //list.Add(m);

            //m = new CColumnsModel();
            //m.FieldText = "处理结果";
            //m.FieldValue = "JK_ArchiveType";
            //m.Formate = "";
            //m.Frozen = false;
            //m.Len = 200;
            //m.Hidden = false;
            //list.Add(m);
            return list;
        }
        #endregion

        //#region 建立审批配置列
        //public static List<CColumnsModel> Create_SPPZColumns()
        //{

        //    List<CColumnsModel> list = new List<CColumnsModel>();
        //    CColumnsModel m = new CColumnsModel();
        //    m.FieldText = "审批流级别";
        //    m.FieldValue = "SP_TOPLEVEL";
        //    m.Formate = "";
        //    m.Frozen = false;
        //    m.Len = 80;
        //    m.Hidden = false;
        //    list.Add(m);

        //    m = new CColumnsModel();
        //    m.FieldText = "本部门审批";
        //    m.FieldValue = "SP_ID1";
        //    m.Formate = "";
        //    m.Frozen = false;
        //    m.Len = 80;
        //    m.Hidden = true;
        //    list.Add(m);

        //    m = new CColumnsModel();
        //    m.FieldText = "档案归档部门审批";
        //    m.FieldValue = "SP_ID2";
        //    m.Formate = "";
        //    m.Frozen = false;
        //    m.Len = 80;
        //    m.Hidden = true;
        //    list.Add(m);

        //    m = new CColumnsModel();
        //    m.FieldText = "档案管理部门审批";
        //    m.FieldValue = "SP_ID3";
        //    m.Formate = "";
        //    m.Frozen = false;
        //    m.Len = 80;
        //    m.Hidden = true;
        //    list.Add(m);

        //    m = new CColumnsModel();
        //    m.FieldText = "配置";
        //    m.FieldValue = "SP_ID";
        //    m.Formate = "formatPZ";
        //    m.Frozen = false;
        //    m.Len = 80;
        //    m.Hidden = true;
        //    list.Add(m);
        //    return list;

        //}
        //#endregion
        #endregion
    }

}